{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "30d4bb23",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "fd5f4023",
   "metadata": {},
   "source": [
    "# 周边搜索\n",
    "* url\n",
    "> https://restapi.amap.com/v3/place/text?parameters\n",
    "\n",
    "* 请求参数（两类）\n",
    "> 1.按照关键词搜索\n",
    "> 2.按照查询poi类型（分类表-下载）"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51fcb1d3",
   "metadata": {},
   "source": [
    "### 关键词搜索"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e8b3bd98",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "37858175",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "payload = {\n",
    "    \"key\":\"3fb026cac6747499fefd1eab6a63817f\",\n",
    "    \"address\":\"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "r = requests.get(url=geo_url, params=payload)\n",
    "广州南方学院_location = r.json()['geocodes'][0]['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "fa8a1f10",
   "metadata": {},
   "outputs": [],
   "source": [
    "around_url = ' https://restapi.amap.com/v3/place/text?parameters'\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"3fb026cac6747499fefd1eab6a63817f\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"keywords\":\"餐厅\"\n",
    "}\n",
    "r = requests.get(around_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "242390d5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'suggestion': {'keywords': [], 'cities': []},\n",
       " 'count': '874',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'parent': [],\n",
       "   'address': '广州南方学院',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '09:00-23:00',\n",
       "    'rating': '4.5',\n",
       "    'open_time': '09:00-23:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;四川菜(川菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/20080ba9f6fcd2808d64ce149b517ca9'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9f40694ca108a175d36847d03ecf4ec0'},\n",
       "    {'title': [],\n",
       "     'url': 'https://img.alicdn.com/imgextra/i2/3695320962/O1CN01JFnmLv1IydhNhdLT4_!!3695320962-0-kbcontentapng.jpg'}],\n",
       "   'typecode': '050102',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '重庆湖边纸包鱼',\n",
       "   'location': '113.680073,23.630511',\n",
       "   'tel': '13924024938',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFL7NUA2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '壹休盖饭',\n",
       "   'location': '113.679611,23.630517',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HRHG0RSP'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中山大学南方学院南门',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.8',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;韩国料理',\n",
       "   'photos': [],\n",
       "   'typecode': '050203',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '炸鸡队长(韩式炸鸡店)',\n",
       "   'location': '113.676603,23.630170',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFHVMT24'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇中大南方',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;休闲餐饮场所;休闲餐饮场所',\n",
       "   'photos': [],\n",
       "   'typecode': '050400',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '初心休闲小屋',\n",
       "   'location': '113.676568,23.631259',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HAFBTLWE'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '东记乡村美食',\n",
       "   'location': '113.679283,23.632572',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3APADKJ'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇牌坊东路45号',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '56.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '4.4',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/098f3972854783f4a0931f73645de6db'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/89a15022589f24ae17885d3374f31a84'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '天天酒家特色农家菜',\n",
       "   'location': '113.657777,23.640442',\n",
       "   'tel': '020-87838296;13533067893',\n",
       "   'shopid': [],\n",
       "   'id': 'B00140LJS7'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉区广州南方学院',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;西餐厅(综合风味)',\n",
       "   'photos': [],\n",
       "   'typecode': '050201',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': 'Uni-hotel西餐',\n",
       "   'location': '113.679222,23.632671',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0GR3OMDZ2'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路99号',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '53.00',\n",
       "    'opentime2': '10:00-21:00',\n",
       "    'rating': '4.6',\n",
       "    'open_time': '10:00-21:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/18132bec7fd836ec909aae4ad8d92e5f'},\n",
       "    {'title': '产品图',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9d00e60d9421930c973d23c0ce6fd0fb'},\n",
       "    {'title': '产品图',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/c12a7ff8105dd732137d63da821b6a5e'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '幸福楼酒店(温泉东路)',\n",
       "   'location': '113.654186,23.644836',\n",
       "   'tel': '020-87838813;020-87838758',\n",
       "   'shopid': [],\n",
       "   'id': 'B00140FG8A'},\n",
       "  {'parent': [],\n",
       "   'address': '村委东侧路与温泉东路西一巷交叉口东北约20米',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '3.5',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;其它亚洲菜',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/589899a0d77b1d90ab2ffc33efca04e3'}],\n",
       "   'typecode': '050217',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '柴火烧肉',\n",
       "   'location': '113.658722,23.642190',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFK6BPAQ'},\n",
       "  {'parent': [],\n",
       "   'address': '东埔附近',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '4.3',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '温泉东埔农庄',\n",
       "   'location': '113.662092,23.659556',\n",
       "   'tel': '13602211368;13902323168',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFF5KYEU'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇龙岗村延庆里10号',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '10:00-20:00',\n",
       "    'rating': '3.6',\n",
       "    'open_time': '10:00-20:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/488b38e7d12a144375129ee602523c88'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/80f404bf446ee2e83bb77c29157fa824'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/b2b8ccd876a1fe963da5f10b13c7d50e'}],\n",
       "   'typecode': '050103',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '四季农庄',\n",
       "   'location': '113.664197,23.597786',\n",
       "   'tel': '13434279298',\n",
       "   'shopid': [],\n",
       "   'id': 'B0IAMAHNK3'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路62号碧泉一横街二巷',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '09:30-21:30',\n",
       "    'rating': '4.1',\n",
       "    'open_time': '09:30-21:30',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/de46d11cc1c2d594328e981e47c30465'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/b3b9e19f80b52a27b9ef6717e2726d17'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/de240fa82a66bbc41319854ca9d8b9d9'}],\n",
       "   'typecode': '050103',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '乡约私房菜馆',\n",
       "   'location': '113.654213,23.644589',\n",
       "   'tel': '15918498423',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFLBF6O0'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉东路97号毅华温泉酒店2层',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '68.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '3.9',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/34ac1a59b88c3b41ca8b59e650fce734'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/2b95c34e6d0df8893c6bdc2bd77270fa'},\n",
       "    {'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/115879d576c7b6de8ffd6bc31b2ab8b1'}],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '毅华轩酒家(温泉镇店)',\n",
       "   'location': '113.653770,23.644272',\n",
       "   'tel': '020-62163888',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFF4BZI3'},\n",
       "  {'parent': 'B00141ICQP',\n",
       "   'address': '温泉镇温泉西路21号财富度假酒店',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': '42.00',\n",
       "    'opentime2': [],\n",
       "    'rating': '4.1',\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': '312',\n",
       "   'adname': '从化区',\n",
       "   'name': '财富度假酒店中餐厅(温泉西路店)',\n",
       "   'location': '113.643299,23.638148',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKQOQJS'},\n",
       "  {'parent': [],\n",
       "   'address': '广卅市温镇天湖路9号之二首层,二层',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '10:30-01:00',\n",
       "    'rating': '4.0',\n",
       "    'open_time': '10:30-01:00',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/8ff8d52ed9fc591f978710ffe7880c97'}],\n",
       "   'typecode': '050103',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '农家私厨',\n",
       "   'location': '113.644567,23.638855',\n",
       "   'tel': '13926487938',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFMBHDOL'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇石坑村东儒队00762号',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;外国餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050200',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '米斯特比萨',\n",
       "   'location': '113.698059,23.611033',\n",
       "   'tel': '13533792521',\n",
       "   'shopid': [],\n",
       "   'id': 'B0FFKT17JQ'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇温泉乌土村随便公寓',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;韩国料理',\n",
       "   'photos': [],\n",
       "   'typecode': '050203',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '鸡啤咯哒(中大店)',\n",
       "   'location': '113.680035,23.631318',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0HROCMJ59'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉明月山溪广场及第大街18-20档',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': '08:00-14:30；17:00-21:30',\n",
       "    'rating': '4.2',\n",
       "    'open_time': '08:00-14:30 17:00-21:30',\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'photos': [{'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/6924b6c0041a860033ce25b0a17efed0'}],\n",
       "   'typecode': '050103',\n",
       "   'shopinfo': '1',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '枢哥私厨农庄',\n",
       "   'location': '113.636524,23.626752',\n",
       "   'tel': '020-37977660;13711095933',\n",
       "   'shopid': [],\n",
       "   'id': 'B0G3K5OP8U'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'opentime2': [],\n",
       "    'rating': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;外国餐厅;外国餐厅',\n",
       "   'photos': [],\n",
       "   'typecode': '050200',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '铁板烧',\n",
       "   'location': '113.679405,23.632673',\n",
       "   'tel': [],\n",
       "   'shopid': [],\n",
       "   'id': 'B0H6ZUSDBT'},\n",
       "  {'parent': [],\n",
       "   'address': '温泉东路113号',\n",
       "   'distance': [],\n",
       "   'pname': '广东省',\n",
       "   'importance': [],\n",
       "   'biz_ext': {'cost': [],\n",
       "    'star': [],\n",
       "    'opentime2': [],\n",
       "    'rating': '4.5',\n",
       "    'lowest_price': [],\n",
       "    'hotel_ordering': [],\n",
       "    'open_time': [],\n",
       "    'meal_ordering': '0'},\n",
       "   'biz_type': 'diner',\n",
       "   'cityname': '广州市',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅|住宿服务;宾馆酒店;宾馆酒店',\n",
       "   'photos': [{'provider': [],\n",
       "     'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/0d16418bc6bca5cfe11506d2748cd3a9'},\n",
       "    {'provider': [],\n",
       "     'title': [],\n",
       "     'url': 'http://store.is.autonavi.com/showpic/892924547d6fc4415dbbb474f9138613'}],\n",
       "   'typecode': '050100|100100',\n",
       "   'shopinfo': '0',\n",
       "   'poiweight': [],\n",
       "   'childtype': [],\n",
       "   'adname': '从化区',\n",
       "   'name': '怡东楼宾馆',\n",
       "   'location': '113.653053,23.653028',\n",
       "   'tel': '020-87839122;020-87839146',\n",
       "   'shopid': [],\n",
       "   'id': 'B0G0O5VQRS'}],\n",
       " 'status': '1',\n",
       " 'info': 'OK'}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "424bf1bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "8ae3036b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>parent</th>\n",
       "      <th>address</th>\n",
       "      <th>distance</th>\n",
       "      <th>pname</th>\n",
       "      <th>importance</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>type</th>\n",
       "      <th>photos</th>\n",
       "      <th>typecode</th>\n",
       "      <th>...</th>\n",
       "      <th>shopid</th>\n",
       "      <th>id</th>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "      <th>biz_ext.star</th>\n",
       "      <th>biz_ext.lowest_price</th>\n",
       "      <th>biz_ext.hotel_ordering</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;四川菜(川菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050102</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFL7NUA2</td>\n",
       "      <td>[]</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇乌土村上围2队13号</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HRHG0RSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中山大学南方学院南门</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;韩国料理</td>\n",
       "      <td>[]</td>\n",
       "      <td>050203</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHVMT24</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.8</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;休闲餐饮场所;休闲餐饮场所</td>\n",
       "      <td>[]</td>\n",
       "      <td>050400</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HAFBTLWE</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3APADKJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇牌坊东路45号</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00140LJS7</td>\n",
       "      <td>56.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.4</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉区广州南方学院</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;西餐厅(综合风味)</td>\n",
       "      <td>[]</td>\n",
       "      <td>050201</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0GR3OMDZ2</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路99号</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00140FG8A</td>\n",
       "      <td>53.00</td>\n",
       "      <td>10:00-21:00</td>\n",
       "      <td>4.6</td>\n",
       "      <td>10:00-21:00</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>村委东侧路与温泉东路西一巷交叉口东北约20米</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;其它亚洲菜</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050217</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFK6BPAQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>东埔附近</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFF5KYEU</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.3</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇龙岗村延庆里10号</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050103</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0IAMAHNK3</td>\n",
       "      <td>[]</td>\n",
       "      <td>10:00-20:00</td>\n",
       "      <td>3.6</td>\n",
       "      <td>10:00-20:00</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路62号碧泉一横街二巷</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050103</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFLBF6O0</td>\n",
       "      <td>[]</td>\n",
       "      <td>09:30-21:30</td>\n",
       "      <td>4.1</td>\n",
       "      <td>09:30-21:30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉东路97号毅华温泉酒店2层</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFF4BZI3</td>\n",
       "      <td>68.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B00141ICQP</td>\n",
       "      <td>温泉镇温泉西路21号财富度假酒店</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFKQOQJS</td>\n",
       "      <td>42.00</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.1</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>广卅市温镇天湖路9号之二首层,二层</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050103</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFMBHDOL</td>\n",
       "      <td>[]</td>\n",
       "      <td>10:30-01:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10:30-01:00</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇石坑村东儒队00762号</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;外国餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050200</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFKT17JQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇温泉乌土村随便公寓</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;韩国料理</td>\n",
       "      <td>[]</td>\n",
       "      <td>050203</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0HROCMJ59</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉明月山溪广场及第大街18-20档</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>050103</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G3K5OP8U</td>\n",
       "      <td>[]</td>\n",
       "      <td>08:00-14:30；17:00-21:30</td>\n",
       "      <td>4.2</td>\n",
       "      <td>08:00-14:30 17:00-21:30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;外国餐厅;外国餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>050200</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0H6ZUSDBT</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[]</td>\n",
       "      <td>温泉东路113号</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>diner</td>\n",
       "      <td>广州市</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅|住宿服务;宾馆酒店;宾馆酒店</td>\n",
       "      <td>[{'provider': [], 'title': [], 'url': 'http://...</td>\n",
       "      <td>050100|100100</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0G0O5VQRS</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        parent                 address distance pname importance biz_type  \\\n",
       "0           []                  广州南方学院       []   广东省         []    diner   \n",
       "1           []           温泉镇乌土村上围2队13号       []   广东省         []    diner   \n",
       "2           []           温泉镇中山大学南方学院南门       []   广东省         []    diner   \n",
       "3           []                 温泉镇中大南方       []   广东省         []    diner   \n",
       "4           []  温泉镇广州南方学院后门润泰超市1层05号商铺       []   广东省         []    diner   \n",
       "5           []              温泉镇牌坊东路45号       []   广东省         []    diner   \n",
       "6           []               温泉区广州南方学院       []   广东省         []    diner   \n",
       "7           []              温泉镇温泉东路99号       []   广东省         []    diner   \n",
       "8           []  村委东侧路与温泉东路西一巷交叉口东北约20米       []   广东省         []    diner   \n",
       "9           []                    东埔附近       []   广东省         []    diner   \n",
       "10          []            温泉镇龙岗村延庆里10号       []   广东省         []    diner   \n",
       "11          []       温泉镇温泉东路62号碧泉一横街二巷       []   广东省         []    diner   \n",
       "12          []      温泉镇温泉东路97号毅华温泉酒店2层       []   广东省         []    diner   \n",
       "13  B00141ICQP        温泉镇温泉西路21号财富度假酒店       []   广东省         []    diner   \n",
       "14          []       广卅市温镇天湖路9号之二首层,二层       []   广东省         []    diner   \n",
       "15          []         温泉镇石坑村东儒队00762号       []   广东省         []    diner   \n",
       "16          []            温泉镇温泉乌土村随便公寓       []   广东省         []    diner   \n",
       "17          []      温泉明月山溪广场及第大街18-20档       []   广东省         []    diner   \n",
       "18          []  温泉镇广州南方学院后门润泰超市1层05号商铺       []   广东省         []    diner   \n",
       "19          []                温泉东路113号       []   广东省         []    diner   \n",
       "\n",
       "   cityname                         type  \\\n",
       "0       广州市             餐饮服务;中餐厅;四川菜(川菜)   \n",
       "1       广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "2       广州市               餐饮服务;外国餐厅;韩国料理   \n",
       "3       广州市           餐饮服务;休闲餐饮场所;休闲餐饮场所   \n",
       "4       广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "5       广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "6       广州市          餐饮服务;外国餐厅;西餐厅(综合风味)   \n",
       "7       广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "8       广州市              餐饮服务;外国餐厅;其它亚洲菜   \n",
       "9       广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "10      广州市             餐饮服务;中餐厅;广东菜(粤菜)   \n",
       "11      广州市             餐饮服务;中餐厅;广东菜(粤菜)   \n",
       "12      广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "13      广州市                 餐饮服务;中餐厅;中餐厅   \n",
       "14      广州市             餐饮服务;中餐厅;广东菜(粤菜)   \n",
       "15      广州市               餐饮服务;外国餐厅;外国餐厅   \n",
       "16      广州市               餐饮服务;外国餐厅;韩国料理   \n",
       "17      广州市             餐饮服务;中餐厅;广东菜(粤菜)   \n",
       "18      广州市               餐饮服务;外国餐厅;外国餐厅   \n",
       "19      广州市  餐饮服务;中餐厅;中餐厅|住宿服务;宾馆酒店;宾馆酒店   \n",
       "\n",
       "                                               photos       typecode  ...  \\\n",
       "0   [{'title': [], 'url': 'http://store.is.autonav...         050102  ...   \n",
       "1                                                  []         050100  ...   \n",
       "2                                                  []         050203  ...   \n",
       "3                                                  []         050400  ...   \n",
       "4                                                  []         050100  ...   \n",
       "5   [{'title': [], 'url': 'http://store.is.autonav...         050100  ...   \n",
       "6                                                  []         050201  ...   \n",
       "7   [{'title': [], 'url': 'http://store.is.autonav...         050100  ...   \n",
       "8   [{'title': [], 'url': 'http://store.is.autonav...         050217  ...   \n",
       "9                                                  []         050100  ...   \n",
       "10  [{'title': [], 'url': 'http://store.is.autonav...         050103  ...   \n",
       "11  [{'title': [], 'url': 'http://store.is.autonav...         050103  ...   \n",
       "12  [{'title': [], 'url': 'http://store.is.autonav...         050100  ...   \n",
       "13                                                 []         050100  ...   \n",
       "14  [{'title': [], 'url': 'http://store.is.autonav...         050103  ...   \n",
       "15                                                 []         050200  ...   \n",
       "16                                                 []         050203  ...   \n",
       "17  [{'title': [], 'url': 'http://store.is.autonav...         050103  ...   \n",
       "18                                                 []         050200  ...   \n",
       "19  [{'provider': [], 'title': [], 'url': 'http://...  050100|100100  ...   \n",
       "\n",
       "   shopid          id biz_ext.cost        biz_ext.opentime2 biz_ext.rating  \\\n",
       "0      []  B0FFL7NUA2           []              09:00-23:00            4.5   \n",
       "1      []  B0HRHG0RSP           []                       []             []   \n",
       "2      []  B0FFHVMT24           []                       []            3.8   \n",
       "3      []  B0HAFBTLWE           []                       []             []   \n",
       "4      []  B0G3APADKJ           []                       []             []   \n",
       "5      []  B00140LJS7        56.00                       []            4.4   \n",
       "6      []  B0GR3OMDZ2           []                       []             []   \n",
       "7      []  B00140FG8A        53.00              10:00-21:00            4.6   \n",
       "8      []  B0FFK6BPAQ           []                       []            3.5   \n",
       "9      []  B0FFF5KYEU           []                       []            4.3   \n",
       "10     []  B0IAMAHNK3           []              10:00-20:00            3.6   \n",
       "11     []  B0FFLBF6O0           []              09:30-21:30            4.1   \n",
       "12     []  B0FFF4BZI3        68.00                       []            3.9   \n",
       "13     []  B0FFKQOQJS        42.00                       []            4.1   \n",
       "14     []  B0FFMBHDOL           []              10:30-01:00            4.0   \n",
       "15     []  B0FFKT17JQ           []                       []             []   \n",
       "16     []  B0HROCMJ59           []                       []             []   \n",
       "17     []  B0G3K5OP8U           []  08:00-14:30；17:00-21:30            4.2   \n",
       "18     []  B0H6ZUSDBT           []                       []             []   \n",
       "19     []  B0G0O5VQRS           []                       []            4.5   \n",
       "\n",
       "          biz_ext.open_time biz_ext.meal_ordering biz_ext.star  \\\n",
       "0               09:00-23:00                     0          NaN   \n",
       "1                        []                     0          NaN   \n",
       "2                        []                     0          NaN   \n",
       "3                        []                     0          NaN   \n",
       "4                        []                     0          NaN   \n",
       "5                        []                     0          NaN   \n",
       "6                        []                     0          NaN   \n",
       "7               10:00-21:00                     0          NaN   \n",
       "8                        []                     0          NaN   \n",
       "9                        []                     0          NaN   \n",
       "10              10:00-20:00                     0          NaN   \n",
       "11              09:30-21:30                     0          NaN   \n",
       "12                       []                     0          NaN   \n",
       "13                       []                     0          NaN   \n",
       "14              10:30-01:00                     0          NaN   \n",
       "15                       []                     0          NaN   \n",
       "16                       []                     0          NaN   \n",
       "17  08:00-14:30 17:00-21:30                     0          NaN   \n",
       "18                       []                     0          NaN   \n",
       "19                       []                     0           []   \n",
       "\n",
       "   biz_ext.lowest_price biz_ext.hotel_ordering  \n",
       "0                   NaN                    NaN  \n",
       "1                   NaN                    NaN  \n",
       "2                   NaN                    NaN  \n",
       "3                   NaN                    NaN  \n",
       "4                   NaN                    NaN  \n",
       "5                   NaN                    NaN  \n",
       "6                   NaN                    NaN  \n",
       "7                   NaN                    NaN  \n",
       "8                   NaN                    NaN  \n",
       "9                   NaN                    NaN  \n",
       "10                  NaN                    NaN  \n",
       "11                  NaN                    NaN  \n",
       "12                  NaN                    NaN  \n",
       "13                  NaN                    NaN  \n",
       "14                  NaN                    NaN  \n",
       "15                  NaN                    NaN  \n",
       "16                  NaN                    NaN  \n",
       "17                  NaN                    NaN  \n",
       "18                  NaN                    NaN  \n",
       "19                   []                     []  \n",
       "\n",
       "[20 rows x 27 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b6299e7e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
